Collin County RE Data Analysis

Dataset statistics

Number of variables	39
Number of observations	125047
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.2 MiB
Average record size in memory	312.0 B

Variable types

CAT	21
NUM	17
UNSUPPORTED	1

Reproduction

Analysis started	2020-05-23 04:52:50.378442
Analysis finished	2020-05-23 04:55:51.517629
Duration	3 minutes and 1.14 second
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`CloseDate` has a high cardinality: 5066 distinct values	High cardinality
`ElementarySchoolName` has a high cardinality: 185 distinct values	High cardinality
`HighSchoolName` has a high cardinality: 80 distinct values	High cardinality
`MiddleSchoolName` has a high cardinality: 90 distinct values	High cardinality
`StreetName` has a high cardinality: 15170 distinct values	High cardinality
`StreetNumber` has a high cardinality: 10358 distinct values	High cardinality
`ArchitecturalStyle` has a high cardinality: 265 distinct values	High cardinality
`TaxLegalDescription` has a high cardinality: 61975 distinct values	High cardinality
`CurrentPrice` is highly correlated with `ClosePrice` and 1 other fields	High correlation
`ClosePrice` is highly correlated with `CurrentPrice` and 1 other fields	High correlation
`ListPrice` is highly correlated with `ClosePrice` and 1 other fields	High correlation
`City` is highly correlated with `PostalCode`	High correlation
`PostalCode` is highly correlated with `City`	High correlation
`SchoolDistrict` is highly correlated with `HighSchoolName`	High correlation
`HighSchoolName` is highly correlated with `SchoolDistrict`	High correlation
`OriginalListPrice` is highly skewed (γ1 = 233.4566206)	Skewed
`RATIO_ClosePrice_By_ListPrice` is highly skewed (γ1 = 344.1918627)	Skewed
`RATIO_ClosePrice_By_OriginalListPrice` is highly skewed (γ1 = 274.7697374)	Skewed
`df_index` has unique values	Unique
`MLSNumber` has unique values	Unique
`PoolYN` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`DOM` has 1721 (1.4%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	125047
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	108788.37733012387
Minimum	0
Maximum	213410
Zeros	1
Zeros (%)	< 0.1%
Memory size	976.9 KiB

Quantile statistics

Minimum	0
5-th percentile	11786.3
Q1	55937.5
median	109879
Q3	162497.5
95-th percentile	203452.7
Maximum	213410
Range	213410
Interquartile range (IQR)	106560

Descriptive statistics

Standard deviation	61390.45463
Coefficient of variation (CV)	0.5643107852
Kurtosis	-1.198913273
Mean	108788.3773
Median Absolute Deviation (MAD)	53122
Skewness	-0.03591243307
Sum	1.360366022e+10
Variance	3768787920

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
8188	1	< 0.1%
133995	1	< 0.1%
146285	1	< 0.1%
140142	1	< 0.1%
142191	1	< 0.1%
187249	1	< 0.1%
181106	1	< 0.1%
183155	1	< 0.1%
195445	1	< 0.1%
189302	1	< 0.1%
Other values (125037)	125037	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
213410	1	< 0.1%
213408	1	< 0.1%
213404	1	< 0.1%
213403	1	< 0.1%
213400	1	< 0.1%

PostalCode
Categorical

HIGH CORRELATION

Distinct count	23
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

75070	25294
75035	15458
75025	12210
75023	11408
75071	10997
Other values (18)	49680

Common Values
Length

Value	Count	Frequency (%)
75070	25294	20.2%
75035	15458	12.4%
75025	12210	9.8%
75023	11408	9.1%
75071	10997	8.8%
75093	10453	8.4%
75074	7817	6.3%
75075	7643	6.1%
75069	6151	4.9%
75024	6018	4.8%
Other values (13)	11598	9.3%

Length

Max length	5
Median length	5
Mean length	5
Min length	5

BathsTotal
Real number (ℝ_≥0)

Distinct count	24
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.5102419043215125
Minimum	0.2
Maximum	4.4
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	2
median	2.1
Q3	3
95-th percentile	4
Maximum	4.4
Range	4.2
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7130176022
Coefficient of variation (CV)	0.2840433828
Kurtosis	-0.1044490754
Mean	2.510241904
Median Absolute Deviation (MAD)	0.1
Skewness	0.7876034045
Sum	313898.2194
Variance	0.508394101

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	45464	36.4%
2.1	26942	21.5%
3.1	16990	13.6%
3	16616	13.3%
4	7499	6.0%
4.1	4897	3.9%
2.554600004	2189	1.8%
1	1582	1.3%
1.1	1342	1.1%
3.2	642	0.5%
Other values (14)	884	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	4	< 0.1%
1	1582	1.3%
1.1	1342	1.1%
1.2	6	< 0.1%
1.3	1	< 0.1%

Value	Count	Frequency (%)
4.4	2	< 0.1%
4.3	33	< 0.1%
4.2	529	0.4%
4.1	4897	3.9%
4	7499	6.0%

BedsTotal
Real number (ℝ_≥0)

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.6888161098080356
Minimum	2.0
Maximum	6.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	3
median	4
Q3	4
95-th percentile	5
Maximum	6
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7608766784
Coefficient of variation (CV)	0.2062658196
Kurtosis	-0.1310451097
Mean	3.68881611
Median Absolute Deviation (MAD)	1
Skewness	0.1431610738
Sum	461275.3881
Variance	0.5789333197

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	57469	46.0%
3	45976	36.8%
5	15420	12.3%
2	4939	3.9%
6	827	0.7%
3.681221354	416	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	4939	3.9%
3	45976	36.8%
3.681221354	416	0.3%
4	57469	46.0%
5	15420	12.3%

Value	Count	Frequency (%)
6	827	0.7%
5	15420	12.3%
4	57469	46.0%
3.681221354	416	0.3%
3	45976	36.8%

City
Categorical

HIGH CORRELATION

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Plano	55958
McKinney	41612
Frisco	21955
Prosper	3172
Fairview	2350

Common Values
Length

Value	Count	Frequency (%)
Plano	55958	44.7%
McKinney	41612	33.3%
Frisco	21955	17.6%
Prosper	3172	2.5%
Fairview	2350	1.9%

Length

Max length	8
Median length	6
Mean length	6.280998345
Min length	5

CloseDate
Categorical

HIGH CARDINALITY

Distinct count	5066
Unique (%)	4.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

6/30/2005	144
6/28/2013	117
6/30/2006	116
6/30/2016	116
6/30/2014	108
Other values (5061)	124446

Common Values
Length

Value	Count	Frequency (%)
6/30/2005	144	0.1%
6/28/2013	117	0.1%
6/30/2006	116	0.1%
6/30/2016	116	0.1%
6/30/2014	108	0.1%
4/28/2006	102	0.1%
6/30/2017	101	0.1%
7/31/2013	101	0.1%
5/29/2015	100	0.1%
7/31/2017	100	0.1%
Other values (5056)	123942	99.1%

Length

Max length	10
Median length	9
Mean length	8.990659512
Min length	8

ClosePrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	9358
Unique (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	268627.58233656303
Minimum	70.0
Maximum	859000.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	70
5-th percentile	119900
Q1	173000
median	243500
Q3	327000
95-th percentile	529000
Maximum	859000
Range	858930
Interquartile range (IQR)	154000

Descriptive statistics

Standard deviation	131072.3245
Coefficient of variation (CV)	0.4879332322
Kurtosis	2.565569061
Mean	268627.5823
Median Absolute Deviation (MAD)	75000
Skewness	1.39983177
Sum	3.359107329e+10
Variance	1.717995425e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
282180.7367	2079	1.7%
250000	1016	0.8%
225000	893	0.7%
275000	882	0.7%
300000	833	0.7%
260000	797	0.6%
265000	792	0.6%
215000	782	0.6%
165000	779	0.6%
210000	775	0.6%
Other values (9348)	115419	92.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70	1	< 0.1%
81	1	< 0.1%
110	1	< 0.1%
165	1	< 0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
859000	2	< 0.1%
857500	2	< 0.1%
857000	2	< 0.1%
856000	1	< 0.1%
855000	14	< 0.1%

CurrentPrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	9357
Unique (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	268624.7138869516
Minimum	70.0
Maximum	859000.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	70
5-th percentile	119900
Q1	173000
median	243500
Q3	327000
95-th percentile	529000
Maximum	859000
Range	858930
Interquartile range (IQR)	154000

Descriptive statistics

Standard deviation	131067.9174
Coefficient of variation (CV)	0.4879220363
Kurtosis	2.565871441
Mean	268624.7139
Median Absolute Deviation (MAD)	75000
Skewness	1.39984281
Sum	3.35907146e+10
Variance	1.717879897e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
282184.7647	2080	1.7%
250000	1016	0.8%
225000	893	0.7%
275000	882	0.7%
300000	833	0.7%
260000	797	0.6%
265000	792	0.6%
215000	782	0.6%
165000	779	0.6%
210000	775	0.6%
Other values (9347)	115418	92.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
70	1	< 0.1%
81	1	< 0.1%
110	1	< 0.1%
165	1	< 0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
859000	2	< 0.1%
857500	2	< 0.1%
857000	2	< 0.1%
856000	1	< 0.1%
855000	14	< 0.1%

DOM
Real number (ℝ)

ZEROS

Distinct count	270
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	43.46638886885942
Minimum	-97.0
Maximum	230.0
Zeros	1721
Zeros (%)	1.4%
Memory size	976.9 KiB

Quantile statistics

Minimum	-97
5-th percentile	2
Q1	9
median	27
Q3	62
95-th percentile	143
Maximum	230
Range	327
Interquartile range (IQR)	53

Descriptive statistics

Standard deviation	45.60984764
Coefficient of variation (CV)	1.049313017
Kurtosis	2.062862347
Mean	43.46638887
Median Absolute Deviation (MAD)	21.89610227
Skewness	1.525618601
Sum	5435341.529
Variance	2080.258201

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	5029	4.0%
4	4835	3.9%
5	4116	3.3%
2	3701	3.0%
6	3270	2.6%
7	3034	2.4%
10	2548	2.0%
8	2542	2.0%
11	2271	1.8%
9	2215	1.8%
Other values (260)	91486	73.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-97	15	< 0.1%
-67	1	< 0.1%
-58	1	< 0.1%
-41	2	< 0.1%
-39	1	< 0.1%

Value	Count	Frequency (%)
230	32	< 0.1%
229	30	< 0.1%
228	24	< 0.1%
227	33	< 0.1%
226	33	< 0.1%

ElementarySchoolName
Categorical

HIGH CARDINALITY

Distinct count	185
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Christie	4841
Thomas	2615
Glenoaks	2520
Johnson	2502
Curtsinger	2327
Other values (180)	110242

Common Values
Length

Value	Count	Frequency (%)
Christie	4841	3.9%
Thomas	2615	2.1%
Glenoaks	2520	2.0%
Johnson	2502	2.0%
Curtsinger	2327	1.9%
Gunstream	2300	1.8%
Bennett	2261	1.8%
Shawnee	2193	1.8%
Spears	2149	1.7%
Wolford	2115	1.7%
Other values (175)	99224	79.3%

Length

Max length	27
Median length	7
Mean length	7.630498932
Min length	3

HighSchoolName
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	80
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Mckinney	12883
Jasper	11979
Clark	11430
Centennial	10792
Vines	10303
Other values (75)	67660

Common Values
Length

Value	Count	Frequency (%)
Mckinney	12883	10.3%
Jasper	11979	9.6%
Clark	11430	9.1%
Centennial	10792	8.6%
Vines	10303	8.2%
Mckinney Boyd	10010	8.0%
Shepton	7880	6.3%
Frisco	7816	6.3%
Mckinneyno	7659	6.1%
Williams	6692	5.4%
Other values (70)	27603	22.1%

Length

Max length	23
Median length	7
Mean length	7.72353595
Min length	4

AssociationType
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Mandatory	80000
None	37892
Voluntary	7155

Common Values
Length

Value	Count	Frequency (%)
Mandatory	80000	64.0%
None	37892	30.3%
Voluntary	7155	5.7%

Length

Max length	9
Median length	9
Mean length	7.484889681
Min length	4

ListPrice
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	5647
Unique (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	273888.9817317989
Minimum	1.0
Maximum	899500.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	1
5-th percentile	121000
Q1	175000
median	248000
Q3	330000
95-th percentile	545000
Maximum	899500
Range	899499
Interquartile range (IQR)	155000

Descriptive statistics

Standard deviation	135708.2807
Coefficient of variation (CV)	0.4954864551
Kurtosis	2.875316044
Mean	273888.9817
Median Absolute Deviation (MAD)	77000
Skewness	1.476243523
Sum	3.42489955e+10
Variance	1.841673744e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
288190.4166	1994	1.6%
169900	1496	1.2%
159900	1334	1.1%
179900	1329	1.1%
249900	1326	1.1%
199900	1306	1.0%
189900	1247	1.0%
149900	1199	1.0%
299900	1179	0.9%
225000	1084	0.9%
Other values (5637)	111553	89.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
1995	1	< 0.1%
9900	1	< 0.1%
13200	2	< 0.1%
13500	1	< 0.1%

Value	Count	Frequency (%)
899500	2	< 0.1%
899000	66	0.1%
898800	1	< 0.1%
897500	1	< 0.1%
897000	2	< 0.1%

LotSize
Categorical

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Less Than .5 Acre (not Zero)	110556
.5 Acre to .99 Acre	5858
Condo/Townhome Lot	3107
Zero Lot	2552
1 Acre to 2.99 Acres	2383
Other values (6)	591

Common Values
Length

Value	Count	Frequency (%)
Less Than .5 Acre (not Zero)	110556	88.4%
.5 Acre to .99 Acre	5858	4.7%
Condo/Townhome Lot	3107	2.5%
Zero Lot	2552	2.0%
1 Acre to 2.99 Acres	2383	1.9%
3 Acres to 4.99 Acres	290	0.2%
5 Acres to 9.99 Acres	153	0.1%
10 Acres to 49.99 Acres	124	0.1%
Unknown	14	< 0.1%
Over 100 Acres	8	< 0.1%

Length

Max length	28
Median length	28
Mean length	26.7361792
Min length	7

MiddleSchoolName
Categorical

HIGH CARDINALITY

Distinct count	90
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Dowell	8053
Evans	6793
Carpenter	6686
Faubion	6648
Renner	6150
Other values (85)	90717

Common Values
Length

Value	Count	Frequency (%)
Dowell	8053	6.4%
Evans	6793	5.4%
Carpenter	6686	5.3%
Faubion	6648	5.3%
Renner	6150	4.9%
Wester	6076	4.9%
Clark	6073	4.9%
Haggard	5842	4.7%
Roach	5345	4.3%
Robinson	4876	3.9%
Other values (80)	62505	50.0%

Length

Max length	23
Median length	6
Mean length	7.04351164
Min length	4

MLSNumber
Real number (ℝ_≥0)

UNIQUE

Distinct count	125047
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11938490.22800227
Minimum	9308485.0
Maximum	14320678.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	9308485
5-th percentile	9697603.9
Q1	10755366
median	11775494
Q3	13349744.5
95-th percentile	14062955.9
Maximum	14320678
Range	5012193
Interquartile range (IQR)	2594378.5

Descriptive statistics

Standard deviation	1397764.156
Coefficient of variation (CV)	0.1170804791
Kurtosis	-1.27244711
Mean	11938490.23
Median Absolute Deviation (MAD)	1315558
Skewness	0.09434734044
Sum	1.492872388e+12
Variance	1.953744635e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
13224938	1	< 0.1%
13978170	1	< 0.1%
12147595	1	< 0.1%
13978237	1	< 0.1%
13978250	1	< 0.1%
13439447	1	< 0.1%
13978368	1	< 0.1%
13978455	1	< 0.1%
13978474	1	< 0.1%
9719461	1	< 0.1%
Other values (125037)	125037	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9308485	1	< 0.1%
9325434	1	< 0.1%
9326879	1	< 0.1%
9377660	1	< 0.1%
9388582	1	< 0.1%

Value	Count	Frequency (%)
14320678	1	< 0.1%
14320220	1	< 0.1%
14313727	1	< 0.1%
14311113	1	< 0.1%
14311028	1	< 0.1%

NumberOfDiningAreas
Real number (ℝ_≥0)

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.7632680211805638
Minimum	1.0
Maximum	3.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	3
Range	2
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4298011944
Coefficient of variation (CV)	0.2437526169
Kurtosis	-0.3910830869
Mean	1.763268021
Median Absolute Deviation (MAD)	0
Skewness	-1.146245877
Sum	220491.3762
Variance	0.1847290667

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	94294	75.4%
1	29750	23.8%
1.755293788	685	0.5%
3	316	0.3%
1.5	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	29750	23.8%
1.5	2	< 0.1%
1.755293788	685	0.5%
2	94294	75.4%
3	316	0.3%

Value	Count	Frequency (%)
3	316	0.3%
2	94294	75.4%
1.755293788	685	0.5%
1.5	2	< 0.1%
1	29750	23.8%

NumberOfLivingAreas
Real number (ℝ_≥0)

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.0350264391194055
Minimum	0.0
Maximum	4.0
Zeros	66
Zeros (%)	0.1%
Memory size	976.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	3
Maximum	4
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.8487602172
Coefficient of variation (CV)	0.4170757691
Kurtosis	-0.5603384385
Mean	2.035026439
Median Absolute Deviation (MAD)	1
Skewness	0.3995845167
Sum	254473.9511
Variance	0.7203939063

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	51847	41.5%
1	36748	29.4%
3	29138	23.3%
4	6020	4.8%
2.067197337	1227	1.0%
0	66	0.1%
1.5	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	66	0.1%
1	36748	29.4%
1.5	1	< 0.1%
2	51847	41.5%
2.067197337	1227	1.0%

Value	Count	Frequency (%)
4	6020	4.8%
3	29138	23.3%
2.067197337	1227	1.0%
2	51847	41.5%
1.5	1	< 0.1%

NumberOfStories
Real number (ℝ_≥0)

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.531559384031412
Minimum	0.0
Maximum	3.0
Zeros	239
Zeros (%)	0.2%
Memory size	976.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	2
Maximum	3
Range	3
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5109986696
Coefficient of variation (CV)	0.3336460048
Kurtosis	-1.642502973
Mean	1.531559384
Median Absolute Deviation (MAD)	0
Skewness	-0.07586873524
Sum	191516.9063
Variance	0.2611196403

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	65662	52.5%
1	58613	46.9%
3	520	0.4%
0	239	0.2%
1.53125346	13	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	239	0.2%
1	58613	46.9%
1.53125346	13	< 0.1%
2	65662	52.5%
3	520	0.4%

Value	Count	Frequency (%)
3	520	0.4%
2	65662	52.5%
1.53125346	13	< 0.1%
1	58613	46.9%
0	239	0.2%

Occupancy
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Owner	69583
Vacant	29731
Unknown	22977
Tenant	2756

Common Values
Length

Value	Count	Frequency (%)
Owner	69583	55.6%
Vacant	29731	23.8%
Unknown	22977	18.4%
Tenant	2756	2.2%

Length

Max length	7
Median length	5
Mean length	5.627292138
Min length	5

OriginalListPrice
Real number (ℝ_≥0)

SKEWED

Distinct count	6116
Unique (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	305920.79019488674
Minimum	0.0
Maximum	430000000.0
Zeros	17
Zeros (%)	< 0.1%
Memory size	976.9 KiB

Quantile statistics

Minimum	0
5-th percentile	124900
Q1	179000
median	249900
Q3	349894
95-th percentile	619000
Maximum	430000000
Range	430000000
Interquartile range (IQR)	170894

Descriptive statistics

Standard deviation	1548209.316
Coefficient of variation (CV)	5.06081759
Kurtosis	59021.371
Mean	305920.7902
Median Absolute Deviation (MAD)	80000
Skewness	233.4566206
Sum	3.825447705e+10
Variance	2.396952086e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
169900	1372	1.1%
179900	1298	1.0%
249900	1253	1.0%
189900	1213	1.0%
159900	1206	1.0%
199900	1192	1.0%
299900	1121	0.9%
225000	1086	0.9%
149900	1068	0.9%
275000	1045	0.8%
Other values (6106)	113193	90.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	17	< 0.1%
1	10	< 0.1%
320	1	< 0.1%
1000	3	< 0.1%
1990	1	< 0.1%

Value	Count	Frequency (%)
430000000	1	< 0.1%
299900900	1	< 0.1%
126500000	1	< 0.1%
34990000	1	< 0.1%
27990000	1	< 0.1%

ParkingSpacesGarage
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

2	95365
3	22261
2.121943479	5163
1	2258

Common Values
Length

Value	Count	Frequency (%)
2	95365	76.3%
3	22261	17.8%
2.121943479	5163	4.1%
1	2258	1.8%

Length

Max length	18
Median length	3
Mean length	3.619327133
Min length	3

PoolYN
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	977.1 KiB

PropertySubType
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

RES-Single Family	118653
RES-Townhouse	3932
RES-Condo	1562
RES-Half Duplex	841
RES-Farm/Ranch	59

Common Values
Length

Value	Count	Frequency (%)
RES-Single Family	118653	94.9%
RES-Townhouse	3932	3.1%
RES-Condo	1562	1.2%
RES-Half Duplex	841	0.7%
RES-Farm/Ranch	59	< 0.1%

Length

Max length	17
Median length	17
Mean length	16.75942646
Min length	9

RATIO_ClosePrice_By_ListPrice
Real number (ℝ_≥0)

SKEWED

Distinct count	15560
Unique (%)	12.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.9845620951573829
Minimum	0.0005200000000000001
Maximum	150.37594
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	0.00052
5-th percentile	0.92616
Q1	0.96705
median	0.98527
Q3	1
95-th percentile	1.035417
Maximum	150.37594
Range	150.37542
Interquartile range (IQR)	0.03295

Descriptive statistics

Standard deviation	0.4263594304
Coefficient of variation (CV)	0.4330447338
Kurtosis	120545.468
Mean	0.9845620952
Median Absolute Deviation (MAD)	0.01488
Skewness	344.1918627
Sum	123116.5363
Variance	0.1817823639

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	17723	14.2%
0.98039	289	0.2%
0.96	277	0.2%
0.97143	267	0.2%
0.97778	256	0.2%
0.97561	256	0.2%
0.95238	251	0.2%
0.96667	242	0.2%
0.96774	241	0.2%
0.98	235	0.2%
Other values (15550)	105010	84.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00052	1	< 0.1%
0.00054	1	< 0.1%
0.00095	1	< 0.1%
0.00096	1	< 0.1%
0.00097	1	< 0.1%

Value	Count	Frequency (%)
150.37594	1	< 0.1%
10	1	< 0.1%
9.47867	1	< 0.1%
7.54717	1	< 0.1%
3.625	1	< 0.1%

RATIO_ClosePrice_By_OriginalListPrice
Real number (ℝ_≥0)

SKEWED

Distinct count	20716
Unique (%)	16.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.9858464229778092
Minimum	0.0005099999999999999
Maximum	937.5
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	0.00051
5-th percentile	0.86765
Q1	0.94313
median	0.9742
Q3	1
95-th percentile	1.034958
Maximum	937.5
Range	937.49949
Interquartile range (IQR)	0.05687

Descriptive statistics

Standard deviation	2.926540441
Coefficient of variation (CV)	2.968556129
Kurtosis	84872.10176
Mean	0.985846423
Median Absolute Deviation (MAD)	0.0258
Skewness	274.7697374
Sum	123277.1377
Variance	8.564638954

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	12555	10.0%
0.95238	282	0.2%
0.96	259	0.2%
0.97143	228	0.2%
0.96667	216	0.2%
0.95	216	0.2%
0.93333	214	0.2%
0.96774	208	0.2%
0.90909	199	0.2%
0.98039	197	0.2%
Other values (20706)	110473	88.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00051	1	< 0.1%
0.00052	1	< 0.1%
0.00092	1	< 0.1%
0.00093	1	< 0.1%
0.00094	1	< 0.1%

Value	Count	Frequency (%)
937.5	1	< 0.1%
282	1	< 0.1%
208	1	< 0.1%
150.37594	1	< 0.1%
139.9	1	< 0.1%

RATIO_CurrentPrice_By_SQFT
Real number (ℝ_≥0)

Distinct count	15309
Unique (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	104.8170377689334
Minimum	0.03
Maximum	234.31
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	0.03
5-th percentile	64.6
Q1	81
median	97.83
Q3	125.16
95-th percentile	163.45
Maximum	234.31
Range	234.28
Interquartile range (IQR)	44.16

Descriptive statistics

Standard deviation	31.73609278
Coefficient of variation (CV)	0.3027760892
Kurtosis	0.5280328958
Mean	104.8170378
Median Absolute Deviation (MAD)	20.19
Skewness	0.8109784016
Sum	13107056.12
Variance	1007.179585

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
104.6334281	495	0.4%
100	78	0.1%
83.33	76	0.1%
125	59	< 0.1%
90.91	53	< 0.1%
111.11	44	< 0.1%
83.29	42	< 0.1%
85.71	40	< 0.1%
89.29	39	< 0.1%
76.92	39	< 0.1%
Other values (15299)	124082	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.03	1	< 0.1%
0.04	1	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.1	1	< 0.1%

Value	Count	Frequency (%)
234.31	1	< 0.1%
234.26	1	< 0.1%
234.24	1	< 0.1%
234.23	1	< 0.1%
234.1	1	< 0.1%

SchoolDistrict
Categorical

HIGH CORRELATION

Distinct count	14
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Plano ISD	46121
Frisco ISD	32580
McKinney ISD	29211
Unknown	7900
Prosper ISD	6315
Other values (9)	2920

Common Values
Length

Value	Count	Frequency (%)
Plano ISD	46121	36.9%
Frisco ISD	32580	26.1%
McKinney ISD	29211	23.4%
Unknown	7900	6.3%
Prosper ISD	6315	5.1%
Lovejoy ISD	1695	1.4%
Allen ISD	727	0.6%
Lewisville ISD	283	0.2%
Melissa ISD	135	0.1%
Princeton ISD	43	< 0.1%
Other values (4)	37	< 0.1%

Length

Max length	14
Median length	10
Mean length	9.978368134
Min length	7

SellerType
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Individual(s)	115897
Lender/REO	8247
Unknown	903

Common Values
Length

Value	Count	Frequency (%)
Individual(s)	115897	92.7%
Lender/REO	8247	6.6%
Unknown	903	0.7%

Length

Max length	13
Median length	13
Mean length	12.75881868
Min length	7

SeniorHighSchoolName
Categorical

Distinct count	21
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Unknown	78728
Plano Senior	18051
Planoeast	8716
Planowest	8417
Plano West	5186
Other values (16)	5949

Common Values
Length

Value	Count	Frequency (%)
Unknown	78728	63.0%
Plano Senior	18051	14.4%
Planoeast	8716	7.0%
Planowest	8417	6.7%
Plano West	5186	4.1%
Plano East	4074	3.3%
Plano Sr	1710	1.4%
Centennial	67	0.1%
Frisco	57	< 0.1%
Plano	12	< 0.1%
Other values (11)	29	< 0.1%

Length

Max length	12
Median length	7
Mean length	8.232520572
Min length	5

SqFtTotal
Real number (ℝ_≥0)

Distinct count	4734
Unique (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2579.1859871084002
Minimum	0.0
Maximum	5681.0
Zeros	34
Zeros (%)	< 0.1%
Memory size	976.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1389
Q1	1896
median	2416
Q3	3145
95-th percentile	4270
Maximum	5681
Range	5681
Interquartile range (IQR)	1249

Descriptive statistics

Standard deviation	905.0204282
Coefficient of variation (CV)	0.3508938218
Kurtosis	0.1202856612
Mean	2579.185987
Median Absolute Deviation (MAD)	599
Skewness	0.696199964
Sum	322519470.1
Variance	819061.9755

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2623.417724	1384	1.1%
1930	230	0.2%
2098	202	0.2%
1785	197	0.2%
1659	191	0.2%
1535	187	0.1%
1868	183	0.1%
1860	182	0.1%
2297	182	0.1%
1848	179	0.1%
Other values (4724)	121930	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	< 0.1%
49	1	< 0.1%
219	1	< 0.1%
520	1	< 0.1%
525	1	< 0.1%

Value	Count	Frequency (%)
5681	3	< 0.1%
5680	1	< 0.1%
5678	1	< 0.1%
5677	1	< 0.1%
5676	1	< 0.1%

StreetDirPrefix
Categorical

Distinct count	8
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Unknown	121909
N	956
W	899
S	769
E	502
Other values (3)	12

Common Values
Length

Value	Count	Frequency (%)
Unknown	121909	97.5%
N	956	0.8%
W	899	0.7%
S	769	0.6%
E	502	0.4%
NW	5	< 0.1%
NE	4	< 0.1%
SW	3	< 0.1%

Length

Max length	7
Median length	7
Mean length	6.849528577
Min length	1

StreetDirSuffix
Categorical

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Unknown	124579
N	153
S	137
W	101
E	71
Other values (4)	6

Common Values
Length

Value	Count	Frequency (%)
Unknown	124579	99.6%
N	153	0.1%
S	137	0.1%
W	101	0.1%
E	71	0.1%
NW	3	< 0.1%
SE	1	< 0.1%
NE	1	< 0.1%
SW	1	< 0.1%

Length

Max length	7
Median length	7
Mean length	6.977592425
Min length	1

StreetName
Categorical

HIGH CARDINALITY

Distinct count	15170
Unique (%)	12.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Park	258
Virginia Hills	253
Preston	228
Cross Bend	202
Hickory	170
Other values (15165)	123936

Common Values
Length

Value	Count	Frequency (%)
Park	258	0.2%
Virginia Hills	253	0.2%
Preston	228	0.2%
Cross Bend	202	0.2%
Hickory	170	0.1%
Spring Creek	160	0.1%
14th	135	0.1%
Teakwood	130	0.1%
Scenic Ranch	123	0.1%
Mason	115	0.1%
Other values (15160)	123273	98.6%

Length

Max length	20
Median length	9
Mean length	8.921749422
Min length	1

StreetNumber
Categorical

HIGH CARDINALITY

Distinct count	10358
Unique (%)	8.3%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

2601	306
575	273
3101	267
3801	261
2204	247
Other values (10353)	123693

Common Values
Length

Value	Count	Frequency (%)
2601	306	0.2%
575	273	0.2%
3101	267	0.2%
3801	261	0.2%
2204	247	0.2%
2400	230	0.2%
8400	227	0.2%
2524	213	0.2%
2200	204	0.2%
2500	196	0.2%
Other values (10348)	122623	98.1%

Length

Max length	9
Median length	4
Mean length	3.991619151
Min length	1

StreetSuffix
Categorical

Distinct count	45
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Drive	59775
Lane	18690
Unknown	13012
Court	7906
Trail	5245
Other values (40)	20419

Common Values
Length

Value	Count	Frequency (%)
Drive	59775	47.8%
Lane	18690	14.9%
Unknown	13012	10.4%
Court	7906	6.3%
Trail	5245	4.2%
Street	4382	3.5%
Road	4347	3.5%
Circle	3051	2.4%
Way	3040	2.4%
Place	1794	1.4%
Other values (35)	3805	3.0%

Length

Max length	9
Median length	5
Mean length	5.08092957
Min length	3

ArchitecturalStyle
Categorical

HIGH CARDINALITY

Distinct count	265
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Traditional	104488
Unknown	10252
Ranch	2167
Contemporary/Modern	1655
Ranch, Traditional	1175
Other values (260)	5310

Common Values
Length

Value	Count	Frequency (%)
Traditional	104488	83.6%
Unknown	10252	8.2%
Ranch	2167	1.7%
Contemporary/Modern	1655	1.3%
Ranch, Traditional	1175	0.9%
Mediterranean	689	0.6%
Other	486	0.4%
Contemporary/Modern, Traditional	421	0.3%
Craftsman	280	0.2%
French	268	0.2%
Other values (255)	3166	2.5%

Length

Max length	98
Median length	11
Mean length	10.98237463
Min length	4

TaxLegalDescription
Categorical

HIGH CARDINALITY

Distinct count	61975
Unique (%)	49.6%
Missing	0
Missing (%)	0.0%
Memory size	976.9 KiB

Unknown	24030
SPRING CREEK PARKWAY ESTATES W	205
WELLINGTON AT PRESTON MEADOWS	122
Spring Creek Parkway Estates W	121
LAKES OF PRESTON VINEYARDS VIL	108
Other values (61970)	100461

Common Values
Length

Value	Count	Frequency (%)
Unknown	24030	19.2%
SPRING CREEK PARKWAY ESTATES W	205	0.2%
WELLINGTON AT PRESTON MEADOWS	122	0.1%
Spring Creek Parkway Estates W	121	0.1%
LAKES OF PRESTON VINEYARDS VIL	108	0.1%
VILLAGES OF WHITE ROCK CREEK #	98	0.1%
VALOR POINTE - THE RESERVE AT WESTRIDGE PHASE	88	0.1%
BILTMORE SWIM & RACQUET CLUB #	71	0.1%
Wellington At Preston Meadows	71	0.1%
PLANTATION RESORT AUGUSTA FARM	70	0.1%
Other values (61965)	100063	80.0%

Length

Max length	50
Median length	30
Mean length	28.37799387
Min length	1

YearBuilt
Real number (ℝ_≥0)

Distinct count	141
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1994.3325080608063
Minimum	1857.0
Maximum	2020.0
Zeros	0
Zeros (%)	0.0%
Memory size	976.9 KiB

Quantile statistics

Minimum	1857
5-th percentile	1972
Q1	1988
median	1997
Q3	2003
95-th percentile	2010
Maximum	2020
Range	163
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	12.95183265
Coefficient of variation (CV)	0.006494319576
Kurtosis	8.121040881
Mean	1994.332508
Median Absolute Deviation (MAD)	7
Skewness	-1.864597658
Sum	249385297.1
Variance	167.749969

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2005	5873	4.7%
1998	5782	4.6%
2001	5661	4.5%
2000	5631	4.5%
1999	5555	4.4%
2004	5515	4.4%
2006	5474	4.4%
1997	5184	4.1%
2003	4924	3.9%
1996	4861	3.9%
Other values (131)	70587	56.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1857	3	< 0.1%
1860	2	< 0.1%
1876	2	< 0.1%
1877	1	< 0.1%
1878	2	< 0.1%

Value	Count	Frequency (%)
2020	1	< 0.1%
2019	11	< 0.1%
2018	55	< 0.1%
2017	190	0.2%
2016	368	0.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	PostalCode	BathsTotal	BedsTotal	City	CloseDate	ClosePrice	CurrentPrice	DOM	ElementarySchoolName	HighSchoolName	AssociationType	ListPrice	LotSize	MiddleSchoolName	MLSNumber	NumberOfDiningAreas	NumberOfLivingAreas	NumberOfStories	Occupancy	OriginalListPrice	ParkingSpacesGarage	PoolYN	PropertySubType	RATIO_ClosePrice_By_ListPrice	RATIO_ClosePrice_By_OriginalListPrice	RATIO_CurrentPrice_By_SQFT	SchoolDistrict	SellerType	SeniorHighSchoolName	SqFtTotal	StreetDirPrefix	StreetDirSuffix	StreetName	StreetNumber	StreetSuffix	ArchitecturalStyle	TaxLegalDescription	YearBuilt
0	138	75093	2.0000	2.0	Plano	11/27/2002	153200.000000	153200.000000	48.896102	Hightower	Vines	Mandatory	153200.000000	Condo/Townhome Lot	Frankford	9308485.0	1.0	1.000000	1.0	Vacant	161000.0	1.000000	False	RES-Condo	1.00000	0.95155	124.550000	Unknown	Unknown	Plano West	1230.000000	Unknown	Unknown	PRESTON RD.	2524	Unknown	Traditional	Unknown	1995.0
1	552	75093	2.5546	5.0	Plano	10/25/2002	282180.736715	282184.764717	48.896102	Centennial	Shepton	Mandatory	288190.416558	1 Acre to 2.99 Acres	Renner	9325434.0	2.0	4.000000	2.0	Owner	2700000.0	2.121943	True	RES-Single Family	0.90769	1.09259	104.633428	Unknown	Individual(s)	Plano West	2623.417724	Unknown	Unknown	PREAKNESS LN	5600	Unknown	Traditional	Unknown	1987.0
2	176	75093	2.0000	3.0	Plano	2/27/2003	176000.000000	176000.000000	48.896102	Hightower	Shepton	Mandatory	169400.000000	Condo/Townhome Lot	Frankford	9326879.0	1.0	1.000000	2.0	Vacant	147500.0	1.000000	False	RES-Condo	1.03896	1.19322	125.180000	Unknown	Unknown	Plano West	1406.000000	Unknown	Unknown	PRESTON RD.	2524	Unknown	Traditional	Unknown	1995.0
3	748	75093	2.1000	3.0	Plano	11/12/2002	390000.000000	390000.000000	48.896102	Brinker	Shepton	Mandatory	400000.000000	Less Than .5 Acre (not Zero)	Renner	9377660.0	2.0	2.000000	2.0	Owner	425000.0	2.000000	False	RES-Single Family	0.97500	0.91765	127.990000	Unknown	Individual(s)	Plano West	3047.000000	Unknown	Unknown	SUTTON PL	2145	Unknown	Traditional	Unknown	1994.0
4	380	75093	3.2000	5.0	Plano	1/23/2003	282180.736715	282184.764717	48.896102	Barksdale	Shepton	Mandatory	288190.416558	1 Acre to 2.99 Acres	Renner	9388582.0	2.0	2.067197	2.0	Owner	1900000.0	2.000000	True	RES-Single Family	0.88908	0.81842	209.010000	Unknown	Individual(s)	Plano West	2623.417724	Unknown	Unknown	RED WOLF LN	5829	Unknown	Traditional	Unknown	1979.0
5	939	75070	4.0000	4.0	McKinney	10/30/2002	299000.000000	299000.000000	48.896102	Valleycree	Mckinney	Mandatory	325000.000000	Less Than .5 Acre (not Zero)	Faubion	9388720.0	2.0	3.000000	2.0	Vacant	360000.0	3.000000	False	RES-Single Family	0.92000	0.83056	76.080000	Unknown	Individual(s)	Unknown	3930.000000	Unknown	Unknown	FOREST HILLS	1815	Unknown	Traditional	Unknown	1982.0
6	358	75069	3.1000	4.0	Fairview	3/26/2003	625000.000000	625000.000000	48.896102	Lovejoy	Allen	Mandatory	655000.000000	1 Acre to 2.99 Acres	Curtis	9393211.0	2.0	3.000000	2.0	Tenant	699000.0	3.000000	True	RES-Single Family	0.95420	0.89413	118.420000	Unknown	Individual(s)	Unknown	5278.000000	Unknown	Unknown	COUNTRY TRL	991	Unknown	French, Traditional	Unknown	1997.0
7	762	75078	3.1000	4.0	Prosper	12/10/2002	279590.000000	279590.000000	48.896102	Prosper	Prosper	Mandatory	289000.000000	Less Than .5 Acre (not Zero)	Unknown	9396513.0	2.0	3.000000	2.0	Vacant	296274.0	3.000000	False	RES-Single Family	0.96744	0.94369	79.380000	Unknown	Individual(s)	Unknown	3522.000000	Unknown	Unknown	WILLOWGATE DRIVE	910	Unknown	Traditional	LOT 7 BLOCK OC	2001.0
8	2954	75074	3.0000	4.0	Plano	11/5/2002	308000.000000	308000.000000	48.896102	Dooley	Williams	None	339000.000000	1 Acre to 2.99 Acres	Armstrong	9396860.0	1.0	3.000000	1.0	Owner	359000.0	2.000000	True	RES-Single Family	0.90855	0.85794	101.450000	Unknown	Individual(s)	Plano East	3036.000000	Unknown	Unknown	RIDGETOP LN	3840	Unknown	Traditional	Unknown	1972.0
9	1410	75070	3.1000	4.0	McKinney	11/1/2002	559000.000000	559000.000000	48.896102	Glen Oaks	Mckinney	Mandatory	565000.000000	Less Than .5 Acre (not Zero)	Dowell	9397688.0	2.0	1.000000	1.0	Owner	645900.0	3.000000	True	RES-Single Family	0.98938	0.86546	159.710000	Unknown	Individual(s)	Unknown	3500.000000	Unknown	Unknown	COTTON MILL ROAD	1912	Unknown	English	Unknown	2001.0

Last rows

	df_index	PostalCode	BathsTotal	BedsTotal	City	CloseDate	ClosePrice	CurrentPrice	DOM	ElementarySchoolName	HighSchoolName	AssociationType	ListPrice	LotSize	MiddleSchoolName	MLSNumber	NumberOfDiningAreas	NumberOfLivingAreas	NumberOfStories	Occupancy	OriginalListPrice	ParkingSpacesGarage	PoolYN	PropertySubType	RATIO_ClosePrice_By_ListPrice	RATIO_ClosePrice_By_OriginalListPrice	RATIO_CurrentPrice_By_SQFT	SchoolDistrict	SellerType	SeniorHighSchoolName	SqFtTotal	StreetDirPrefix	StreetDirSuffix	StreetName	StreetNumber	StreetSuffix	ArchitecturalStyle	TaxLegalDescription	YearBuilt
125037	205423	75074	2.1	3.0	Plano	4/23/2020	286000.0	286000.0	2.0	Dooley	Mcmillen	None	294900.0	Less Than .5 Acre (not Zero)	Armstrong	14308446.0	2.0	2.0	1.0	Vacant	294900.0	2.000000	False	RES-Single Family	0.96982	0.96982	124.46	Plano ISD	Individual(s)	Plano East	2298.0	Unknown	Unknown	Country Club	4309	Drive	Traditional	LOS RIOS ADDITION PHASE I (CPL), BLK F, LOT 1	1978.0
125038	167143	75074	2.0	4.0	Plano	4/13/2020	170000.0	170000.0	8.0	Aldridge	Clark	None	185000.0	Less Than .5 Acre (not Zero)	Armstrong	14308999.0	1.0	1.0	1.0	Unknown	185000.0	2.000000	False	RES-Single Family	0.91892	0.91892	118.22	Plano ISD	Individual(s)	Plano East	1438.0	Unknown	Unknown	Williamsburg	1512	Drive	Unknown	ARMSTRONG PARK NO 1 (CPL), BLK 2, LOT 10	1968.0
125039	198707	75072	2.0	4.0	McKinney	4/20/2020	376000.0	376000.0	3.0	Valleycree	Mckinney	Mandatory	385000.0	Less Than .5 Acre (not Zero)	Faubion	14309081.0	2.0	2.0	1.0	Owner	385000.0	2.000000	True	RES-Single Family	0.97662	0.97662	155.12	McKinney ISD	Individual(s)	Unknown	2424.0	Unknown	Unknown	Sunset	2817	Ridge	Ranch	SUNSET RIDGE #2 (CMC), BLK M, LOT 26	1989.0
125040	172383	75093	2.1	4.0	Plano	4/17/2020	415000.0	415000.0	7.0	Daffron	Jasper	None	419000.0	Less Than .5 Acre (not Zero)	Robinson	14309257.0	1.0	2.0	1.0	Vacant	419000.0	2.000000	False	RES-Single Family	0.99045	0.99045	169.39	Plano ISD	Individual(s)	Plano West	2450.0	Unknown	Unknown	Mcclary	4105	Drive	Traditional	HOMESTEAD SECTION ONE (CPL), BLK D, LOT 8	1981.0
125041	181887	75070	2.0	3.0	McKinney	4/22/2020	257500.0	257500.0	5.0	Johnson	Mckinney	Mandatory	255000.0	Less Than .5 Acre (not Zero)	Evans	14310390.0	2.0	1.0	1.0	Owner	255000.0	2.000000	False	RES-Single Family	1.00980	1.00980	160.54	McKinney ISD	Individual(s)	Unknown	1604.0	Unknown	Unknown	Dark Forest	6101	Drive	Ranch, Traditional	PINE RIDGE ESTATES PHASE TWO (CMC), BLK J, LO	2000.0
125042	198774	75074	2.0	3.0	Plano	4/14/2020	249900.0	249900.0	3.0	Forman	Mcmillen	None	249900.0	Less Than .5 Acre (not Zero)	Armstrong	14311028.0	1.0	1.0	1.0	Vacant	249900.0	2.000000	False	RES-Single Family	1.00000	1.00000	154.55	Plano ISD	Individual(s)	Unknown	1617.0	Unknown	Unknown	Eastlane	17	Place	Other, Ranch, Traditional	RIDGEWOOD FIRST SECTION (CPL), BLK 22, LOT 17	1971.0
125043	205426	75074	2.1	3.0	Plano	4/17/2020	350000.0	350000.0	2.0	Mccall	Williams	Mandatory	350000.0	Less Than .5 Acre (not Zero)	Bowman	14311113.0	1.0	2.0	2.0	Owner	350000.0	2.000000	False	RES-Single Family	1.00000	1.00000	142.97	Plano ISD	Individual(s)	Unknown	2448.0	Unknown	Unknown	Martello	3013	Lane	Contemporary/Modern	TIMBER BROOK NORTH PHASE II (CPL), BLK A, LOT	2014.0
125044	194503	75023	2.0	3.0	Plano	4/14/2020	215000.0	215000.0	3.0	Christie	Clark	None	199999.0	Less Than .5 Acre (not Zero)	Carpenter	14313727.0	1.0	1.0	1.0	Unknown	199999.0	2.000000	False	RES-Single Family	1.07501	1.07501	104.02	Plano ISD	Individual(s)	Plano Senior	2067.0	Unknown	Unknown	Sundown	5016	Drive	Traditional	TOWN WEST FOUR (CPL), BLK 12, LOT 12	1984.0
125045	211557	75070	2.0	3.0	McKinney	4/27/2020	284000.0	284000.0	0.0	Ogle	Liberty	Mandatory	295000.0	Less Than .5 Acre (not Zero)	Scoggins	14320220.0	2.0	1.0	1.0	Owner	295000.0	2.000000	False	RES-Single Family	0.96271	0.96271	148.93	Frisco ISD	Individual(s)	Unknown	1907.0	Unknown	Unknown	Latigo	8308	Trail	Traditional	CRAIG RANCH NORTH PHASE 10 (CMC), BLK C, LOT	2007.0
125046	196886	75069	1.0	2.0	McKinney	4/15/2020	203800.0	203800.0	3.0	Caldwell	Mckinney	None	199000.0	Less Than .5 Acre (not Zero)	Faubion	14320678.0	1.0	1.0	1.0	Unknown	199000.0	2.121943	False	RES-Single Family	1.02412	1.02412	147.15	McKinney ISD	Individual(s)	Unknown	1385.0	W	Unknown	Virginia	1103	Unknown	Unknown	Unknown	1950.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows